MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

26 rows where Artist Alpha Sort = 6192

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, Artist Role, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
74270 74270 42.124.20 0 0 94599 Costume Institute 8 Shoes 5896 Shoes American 1         Designer 5   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1942 1942 1942 [no medium available] 15100   Gift of Bergdorf Goodman, 1942                           http://www.metmuseum.org/art/collection/search/94599 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74271 74271 42.124.21 0 0 94600 Costume Institute 8 Shoes 5896 Shoes American 1         Designer 5   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1942 1942 1942 [no medium available] 15100   Gift of Bergdorf Goodman, 1942                           http://www.metmuseum.org/art/collection/search/94600 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
76107 76107 42.124.5 0 0 97836 Costume Institute 8 Shoes 5896 Shoes American 1         Designer 5   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1942 1942 1942 [no medium available] 15100   Gift of Bergdorf Goodman, 1942                           http://www.metmuseum.org/art/collection/search/97836 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
76950 76950 42.124.6 0 0 100336 Costume Institute 8 Shoes 5896 Shoes American 1         Designer 5   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1942 1942 1942 [no medium available] 15100   Gift of Bergdorf Goodman, 1942                           http://www.metmuseum.org/art/collection/search/100336 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
79257 79257 42.124.12 0 0 106027 Costume Institute 8 Shoes 5896 Shoes American 1         Designer 5   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1942 1942 1942 [no medium available] 15100   Gift of Bergdorf Goodman, 1942                           http://www.metmuseum.org/art/collection/search/106027 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
82347 82347 C.I.67.44.6a, b 0 0 113462 Costume Institute 8 Pumps 5885 Pumps American 1         Designer 5   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1945–55 1945 1955 leather 15128   Gift of Mrs. J. Grossman, 1967                           http://www.metmuseum.org/art/collection/search/113462 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
82839 82839 1986.517.12a, b 0 0 114315 Costume Institute 8 Evening pumps 5900 Evening pumps American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1963 1958 1968 silk 15101   Gift of Betty Furness, 1986                           http://www.metmuseum.org/art/collection/search/114315 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
82900 82900 1974.302.14a, b 0 0 114411 Costume Institute 8 Evening sandals 5927 Evening sandals American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1950s 1950 1959 [no medium available] 15100   Gift of Mrs. Sidney Bernard, 1974                           http://www.metmuseum.org/art/collection/search/114411 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
82901 82901 1974.302.15a, b 0 0 114412 Costume Institute 8 Evening sandals 5927 Evening sandals American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1950s 1950 1959 [no medium available] 15100   Gift of Mrs. Sidney Bernard, 1974                           http://www.metmuseum.org/art/collection/search/114412 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83012 83012 1977.412.53a, b 0 0 114532 Costume Institute 8 Evening shoes 5884 Evening shoes American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1960–63 1960 1963 silk, glass 15346   Gift of Glady Whitfield Solomon, 1977                           http://www.metmuseum.org/art/collection/search/114532 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83014 83014 1977.412.55a, b 0 0 114534 Costume Institute 8 Evening shoes 5884 Evening shoes American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1960–63 1960 1963 silk, glass 15346   Gift of Glady Whitfield Solomon, 1977                           http://www.metmuseum.org/art/collection/search/114534 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
89891 89891 2009.300.1207a, b 0 0 155896 Costume Institute 8 Evening shoes 5884 Evening shoes American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1935 1935 1935 silk, leather, plastic, rhinestones 19225   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Herman Delman, 1955                           http://www.metmuseum.org/art/collection/search/155896 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
90208 90208 2009.300.1492 0 0 156213 Costume Institute 8 Evening shoes 5884 Evening shoes American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1935 1935 1935 silk, rhinestones 15126   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Herman Delman, 1955                           http://www.metmuseum.org/art/collection/search/156213 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
90248 90248 2009.300.1529a–d 0 0 156253 Costume Institute 8 Shoes 5896 Shoes American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1937–39 1937 1939 leather, silk 15481   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Lewis Iselin Jr., 1960                           http://www.metmuseum.org/art/collection/search/156253 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
94350 94350 2009.300.4818a, b 0 0 169038 Costume Institute 8 Evening sandals 5927 Evening sandals American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1940–49 1940 1949 Leather, silk 4926   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Herman Delman, 1955                           http://www.metmuseum.org/art/collection/search/169038 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
94351 94351 2009.300.4819a, b 0 0 169039 Costume Institute 8 Shoe prototype 6598 Shoe prototype American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1948 1946 1950 Silk, wood 19953   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Herman Delman, 1955                           http://www.metmuseum.org/art/collection/search/169039 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
94352 94352 2009.300.4820 0 0 169040 Costume Institute 8 Boots 5898 "Gloria Boot" American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1943 1941 1945 Leather 732   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Herman Delman, 1955                           http://www.metmuseum.org/art/collection/search/169040 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95292 95292 2009.300.5776a, b 0 0 169980 Costume Institute 8 Shoes 5896 Shoes American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1943 1941 1945 Straw, cork, cotton, shell 20092   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the children of Dr. and Mrs. Hyman Ratnoff, 1970                           http://www.metmuseum.org/art/collection/search/169980 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95294 95294 2009.300.5778a, b 0 0 169982 Costume Institute 8 Sandals 4088 Sandals American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1938 1936 1940 Leather 732   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the children of Dr. and Mrs. Hyman Ratnoff, 1970                           http://www.metmuseum.org/art/collection/search/169982 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95295 95295 2009.300.5779a, b 0 0 169983 Costume Institute 8 Evening shoes 5884 Evening shoes American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1930 1928 1932 Silk, leather 3781   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the children of Dr. and Mrs. Hyman Ratnoff, 1970                           http://www.metmuseum.org/art/collection/search/169983 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95311 95311 2009.300.5795a, b 0 0 169999 Costume Institute 8 Evening pumps 5900 Evening pumps American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1960 1958 1962 Silk, metallic 19804   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Hollis K. Thayer, 1971                           http://www.metmuseum.org/art/collection/search/169999 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95317 95317 2009.300.5801a, b 0 0 170005 Costume Institute 8 Pumps 5885 Pumps American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1958 1956 1960 Leather 732   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Hollis K. Thayer, 1971                           http://www.metmuseum.org/art/collection/search/170005 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95609 95609 2009.300.6082a, b 0 0 170297 Costume Institute 8 Evening sandals 5927 "Nesta" American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1993 1993 1993 Synthetic, leather 20145   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Stanley and Murray Silverstein, Nina Footwear, 1993                           http://www.metmuseum.org/art/collection/search/170297 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95610 95610 2009.300.6083a, b 0 0 170298 Costume Institute 8 Evening shoes 5884 Evening shoes American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 1993 1993 1993 Silk, synthetic; rhinestones 20146   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Stanley and Murray Silverstein, Nina Footwear, 1993                           http://www.metmuseum.org/art/collection/search/170298 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95613 95613 2009.300.5891a, b 0 0 170301 Costume Institute 8 Pumps 5885 Pumps American 1         Manufacturer 20   Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1950 1948 1952 Leather 732   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Mortimer J. Solomon, 1978                           http://www.metmuseum.org/art/collection/search/170301 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95614 95614 2009.300.5892a–c 0 0 170302 Costume Institute 8 Accessory Set 5921 Accessory set American 1         Manufacturer 20 a-b. Delman American, founded 1919   Delman 6192 American 1 1919 9999 ca. 1960 1958 1962 Leather 732   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Mortimer J. Solomon, 1978                           http://www.metmuseum.org/art/collection/search/170302 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 141.547ms · Data license: CC0 · Data source: metmuseum/openaccess